Sorting Records
Server stores records in the order they were added to the table. Sorting in Navicat is used to temporarily rearrange records, so that you can view or update them in a different sequence.
Click the column caption whose contents you want to sort by, then choose Sort Ascending or
Sort Descending from the toolbar.
Hint: Remember to remove all sorting before applying on another column.
To sort by custom order of multi fields, choose Custom Sort from the toolbar. Then, set the sorting fields and the sorting order.
Finding Records
The Find Dialog is provided for quick searching for the text in the editor window. Just simply click Edit -> Find from the menu or press Cmd-F and enter a search string.
The search starts at the cursor's current position to the end of the file. There will not have differentiates when performing a uppercase or lowercase search.
To find for the next text, just simply select Edit -> Find Next or press Cmd-G.